﻿CREATE PROCEDURE [acms].[Topic_GetAllBySiteIdAndTopicGroupPath]
	@SiteId int,
	@TopicGroupPath varchar(50)
AS
	SELECT * 
	From Topic_View a
		inner join TopicGroup b on a.TopicGroupId = b.Id
	Where b.SiteId = @SiteId and b.Path = @TopicGroupPath
	order by a.Sequence

RETURN 0;